Tell me the total spend on products in the most recent cancelled orders of the customer who has the most cancellations in the history
1. Click on the “SALES” button in the dark gray column on the left hand side of the page.
2. Click on “Orders” in the pop up menu, located under the heading “Sales”.
3. Click the “Filters” button, located to the left of the “Default View” button.
4. Click on the “Status” criteria box, located directly under the bolded text “Status”.
5. Click “Canceled” in the pop-up menu.
6. Click the “Apply Filters” button, located near the bottom right of the screen.
7. Scroll down through each row of the orders table, keeping track of which customer has made the most cancellations. The customer can be found in the “Bill-to Name” or “Ship-to Name” columns of a given row.
8. Identify the name of the customer with the greatest number of canceled orders.
9. Click on the “SALES” button in the dark gray column on the left hand side of the page.
10. Click on “Orders” in the pop up menu, located under the heading “Sales”.
11. Click into the search bar, located above the customers table.
12. Type in the name of the customer with the greatest number of canceled orders.
13. Press enter.
14. Click on the “Purchase Date” column header to sort the table from oldest to most recent.
15. Click again on the “Purchase Date” column header to sort the table from most recent to oldest.
16. The total spend on the most recent cancelled order by the customer with the most cancellations is in the "Grand Total (Purchased)" column of the row containing the most recent canceled order by the customer with the most canceled orders.